Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	403776
Missing cells	71286
Missing cells (%)	1.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	55.5 MiB
Average record size in memory	144.0 B

Variable types

Numeric	15
Categorical	3

Alerts

`REF_NO` is highly overall correlated with `year`	High correlation
`PM2.5` is highly overall correlated with `PM10` and 2 other fields	High correlation
`PM10` is highly overall correlated with `PM2.5` and 2 other fields	High correlation
`SO2` is highly overall correlated with `NO2` and 1 other fields	High correlation
`NO2` is highly overall correlated with `PM2.5` and 4 other fields	High correlation
`CO` is highly overall correlated with `PM2.5` and 3 other fields	High correlation
`O3` is highly overall correlated with `NO2` and 1 other fields	High correlation
`TEMP` is highly overall correlated with `O3` and 2 other fields	High correlation
`PRES` is highly overall correlated with `TEMP` and 1 other fields	High correlation
`DEWP` is highly overall correlated with `TEMP` and 1 other fields	High correlation
`year` is highly overall correlated with `REF_NO`	High correlation
`PM2.5` has 8475 (2.1%) missing values	Missing
`PM10` has 6222 (1.5%) missing values	Missing
`SO2` has 8776 (2.2%) missing values	Missing
`NO2` has 11859 (2.9%) missing values	Missing
`CO` has 20261 (5.0%) missing values	Missing
`O3` has 13007 (3.2%) missing values	Missing
`RAIN` is highly skewed (γ1 = 29.4402448)	Skewed
`REF_NO` is uniformly distributed	Uniform
`station` is uniformly distributed	Uniform
`hour` has 16824 (4.2%) zeros	Zeros
`RAIN` has 387119 (95.9%) zeros	Zeros
`WSPM` has 10891 (2.7%) zeros	Zeros

Reproduction

Analysis started	2023-12-09 07:15:43.319593
Analysis finished	2023-12-09 07:16:13.895918
Duration	30.58 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

REF_NO
Real number (ℝ)

HIGH CORRELATION UNIFORM

Distinct	33648
Distinct (%)	8.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16824.5

Minimum	1
Maximum	33648
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1683
Q1	8412.75
median	16824.5
Q3	25236.25
95-th percentile	31966
Maximum	33648
Range	33647
Interquartile range (IQR)	16823.5

Descriptive statistics

Standard deviation	9713.353
Coefficient of variation (CV)	0.57733383
Kurtosis	-1.2
Mean	16824.5
Median Absolute Deviation (MAD)	8412
Skewness	0
Sum	6.7933293 × 10⁹
Variance	94349226
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	12	< 0.1%
22444	12	< 0.1%
22442	12	< 0.1%
22441	12	< 0.1%
22440	12	< 0.1%
22439	12	< 0.1%
22438	12	< 0.1%
22437	12	< 0.1%
22436	12	< 0.1%
22435	12	< 0.1%
Other values (33638)	403656	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	12	< 0.1%
2	12	< 0.1%
3	12	< 0.1%
4	12	< 0.1%
5	12	< 0.1%
6	12	< 0.1%
7	12	< 0.1%
8	12	< 0.1%
9	12	< 0.1%
10	12	< 0.1%

Value	Count	Frequency (%)
33648	12	< 0.1%
33647	12	< 0.1%
33646	12	< 0.1%
33645	12	< 0.1%
33644	12	< 0.1%
33643	12	< 0.1%
33642	12	< 0.1%
33641	12	< 0.1%
33640	12	< 0.1%
33639	12	< 0.1%

year
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

2016	105408
2014	105120
2015	105120
2013	88128

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	1615104
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2013
2nd row	2013
3rd row	2013
4th row	2013
5th row	2013

Common Values

Value	Count	Frequency (%)
2016	105408	26.1%
2014	105120	26.0%
2015	105120	26.0%
2013	88128	21.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	105408	26.1%
2014	105120	26.0%
2015	105120	26.0%
2013	88128	21.8%

Most occurring characters

Value	Count	Frequency (%)
2	403776	25.0%
0	403776	25.0%
1	403776	25.0%
6	105408	6.5%
4	105120	6.5%
5	105120	6.5%
3	88128	5.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1615104	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	403776	25.0%
0	403776	25.0%
1	403776	25.0%
6	105408	6.5%
4	105120	6.5%
5	105120	6.5%
3	88128	5.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	1615104	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	403776	25.0%
0	403776	25.0%
1	403776	25.0%
6	105408	6.5%
4	105120	6.5%
5	105120	6.5%
3	88128	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1615104	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	403776	25.0%
0	403776	25.0%
1	403776	25.0%
6	105408	6.5%
4	105120	6.5%
5	105120	6.5%
3	88128	5.5%

month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.735378

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.3564791
Coefficient of variation (CV)	0.49833566
Kurtosis	-1.157296
Mean	6.735378
Median Absolute Deviation (MAD)	3
Skewness	-0.053269103
Sum	2719584
Variance	11.265952
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	35712	8.8%
5	35712	8.8%
7	35712	8.8%
8	35712	8.8%
10	35712	8.8%
12	35712	8.8%
4	34560	8.6%
6	34560	8.6%
9	34560	8.6%
11	34560	8.6%
Other values (2)	51264	12.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26784	6.6%
2	24480	6.1%
3	35712	8.8%
4	34560	8.6%
5	35712	8.8%
6	34560	8.6%
7	35712	8.8%
8	35712	8.8%
9	34560	8.6%
10	35712	8.8%

Value	Count	Frequency (%)
12	35712	8.8%
11	34560	8.6%
10	35712	8.8%
9	34560	8.6%
8	35712	8.8%
7	35712	8.8%
6	34560	8.6%
5	35712	8.8%
4	34560	8.6%
3	35712	8.8%

day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.748217

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8088915
Coefficient of variation (CV)	0.55935803
Kurtosis	-1.1953252
Mean	15.748217
Median Absolute Deviation (MAD)	8
Skewness	0.0056828267
Sum	6358752
Variance	77.596569
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	13248	3.3%
2	13248	3.3%
28	13248	3.3%
27	13248	3.3%
26	13248	3.3%
25	13248	3.3%
24	13248	3.3%
23	13248	3.3%
22	13248	3.3%
21	13248	3.3%
Other values (21)	271296	67.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13248	3.3%
2	13248	3.3%
3	13248	3.3%
4	13248	3.3%
5	13248	3.3%
6	13248	3.3%
7	13248	3.3%
8	13248	3.3%
9	13248	3.3%
10	13248	3.3%

Value	Count	Frequency (%)
31	7776	1.9%
30	12384	3.1%
29	12672	3.1%
28	13248	3.3%
27	13248	3.3%
26	13248	3.3%
25	13248	3.3%
24	13248	3.3%
23	13248	3.3%
22	13248	3.3%

hour
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.5

Minimum	0
Maximum	23
Zeros	16824
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5.75
median	11.5
Q3	17.25
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11.5

Descriptive statistics

Standard deviation	6.9221951
Coefficient of variation (CV)	0.60193001
Kurtosis	-1.204174
Mean	11.5
Median Absolute Deviation (MAD)	6
Skewness	0
Sum	4643424
Variance	47.916785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	16824	4.2%
1	16824	4.2%
22	16824	4.2%
21	16824	4.2%
20	16824	4.2%
19	16824	4.2%
18	16824	4.2%
17	16824	4.2%
16	16824	4.2%
15	16824	4.2%
Other values (14)	235536	58.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16824	4.2%
1	16824	4.2%
2	16824	4.2%
3	16824	4.2%
4	16824	4.2%
5	16824	4.2%
6	16824	4.2%
7	16824	4.2%
8	16824	4.2%
9	16824	4.2%

Value	Count	Frequency (%)
23	16824	4.2%
22	16824	4.2%
21	16824	4.2%
20	16824	4.2%
19	16824	4.2%
18	16824	4.2%
17	16824	4.2%
16	16824	4.2%
15	16824	4.2%
14	16824	4.2%

PM2.5
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	866
Distinct (%)	0.2%
Missing	8475
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	79.248275

Minimum	2
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	2
5-th percentile	6
Q1	21
median	55
Q3	110
95-th percentile	238
Maximum	999
Range	997
Interquartile range (IQR)	89

Descriptive statistics

Standard deviation	79.146708
Coefficient of variation (CV)	0.99871837
Kurtosis	5.728757
Mean	79.248275
Median Absolute Deviation (MAD)	39
Skewness	1.9742865
Sum	31326922
Variance	6264.2014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	8354	2.1%
10	6609	1.6%
11	6418	1.6%
9	6374	1.6%
12	6346	1.6%
8	6333	1.6%
13	5830	1.4%
14	5765	1.4%
7	5742	1.4%
6	5116	1.3%
Other values (856)	332414	82.3%
(Missing)	8475	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	7	< 0.1%
3	8354	2.1%
4	3221	0.8%
4.3	2	< 0.1%
4.4	1	< 0.1%
4.6	1	< 0.1%
5	3984	1.0%
6	5116	1.3%
7	5742	1.4%
7.2	1	< 0.1%

Value	Count	Frequency (%)
999	1	< 0.1%
957	1	< 0.1%
941	1	< 0.1%
898	1	< 0.1%
882	1	< 0.1%
881	1	< 0.1%
857	1	< 0.1%
844	1	< 0.1%
826	1	< 0.1%
821	1	< 0.1%

PM10
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1048
Distinct (%)	0.3%
Missing	6222
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%
Mean	104.3279

Minimum	2
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	36
median	83
Q3	145
95-th percentile	277
Maximum	999
Range	997
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	90.1364
Coefficient of variation (CV)	0.86397217
Kurtosis	5.7370149
Mean	104.3279
Median Absolute Deviation (MAD)	52
Skewness	1.8164816
Sum	41475973
Variance	8124.5705
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	4712	1.2%
5	3547	0.9%
18	3523	0.9%
14	3493	0.9%
16	3405	0.8%
17	3383	0.8%
13	3349	0.8%
20	3336	0.8%
24	3240	0.8%
21	3229	0.8%
Other values (1038)	362337	89.7%
(Missing)	6222	1.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	103	< 0.1%
3	719	0.2%
4	264	0.1%
5	3547	0.9%
5.4	2	< 0.1%
5.6	1	< 0.1%
6	4712	1.2%
6.4	1	< 0.1%
6.6	1	< 0.1%
7	2245	0.6%

Value	Count	Frequency (%)
999	3	< 0.1%
995	1	< 0.1%
993	1	< 0.1%
992	1	< 0.1%
991	1	< 0.1%
988	1	< 0.1%
987	1	< 0.1%
986	1	< 0.1%
984	1	< 0.1%
983	1	< 0.1%

SO2
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	685
Distinct (%)	0.2%
Missing	8776
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	15.73306

Minimum	0.2856
Maximum	500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0.2856
5-th percentile	2
Q1	2
median	7
Q3	19
95-th percentile	61
Maximum	500
Range	499.7144
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	21.739455
Coefficient of variation (CV)	1.3817691
Kurtosis	14.004989
Mean	15.73306
Median Absolute Deviation (MAD)	5
Skewness	3.0077371
Sum	6214558.7
Variance	472.60392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	97027	24.0%
3	31771	7.9%
4	20810	5.2%
5	17091	4.2%
6	15762	3.9%
7	13639	3.4%
8	12722	3.2%
9	10952	2.7%
10	10096	2.5%
11	8863	2.2%
Other values (675)	156267	38.7%
(Missing)	8776	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2856	89	< 0.1%
0.5712	70	< 0.1%
0.8568	72	< 0.1%
1	3221	0.8%
1.1424	84	< 0.1%
1.428	94	< 0.1%
1.7136	83	< 0.1%
1.9992	110	< 0.1%
2	97027	24.0%
2.1	1	< 0.1%

Value	Count	Frequency (%)
500	3	< 0.1%
411	1	< 0.1%
341	1	< 0.1%
315	1	< 0.1%
314	1	< 0.1%
310	1	< 0.1%
299	1	< 0.1%
282	1	< 0.1%
278	1	< 0.1%
277	1	< 0.1%

NO2
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1209
Distinct (%)	0.3%
Missing	11859
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	50.352785

Minimum	1.0265
Maximum	290
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1.0265
5-th percentile	8
Q1	23
median	43
Q3	71
95-th percentile	116
Maximum	290
Range	288.9735
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	34.77191
Coefficient of variation (CV)	0.69056577
Kurtosis	1.2114205
Mean	50.352785
Median Absolute Deviation (MAD)	23
Skewness	1.0527014
Sum	19734112
Variance	1209.0857
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	5572	1.4%
22	5556	1.4%
20	5523	1.4%
17	5467	1.4%
18	5441	1.3%
26	5420	1.3%
21	5416	1.3%
19	5368	1.3%
14	5366	1.3%
24	5358	1.3%
Other values (1199)	337430	83.6%
(Missing)	11859	2.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.0265	3	< 0.1%
1.2318	2	< 0.1%
1.4371	2	< 0.1%
1.6424	3	< 0.1%
1.8477	1	< 0.1%
2	4364	1.1%
2.053	1	< 0.1%
2.2583	3	< 0.1%
2.4636	1	< 0.1%
2.6689	2	< 0.1%

Value	Count	Frequency (%)
290	1	< 0.1%
285	1	< 0.1%
280	1	< 0.1%
277	2	< 0.1%
273	1	< 0.1%
270	1	< 0.1%
269	1	< 0.1%
265	1	< 0.1%
264	1	< 0.1%
263	2	< 0.1%

CO
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	132
Distinct (%)	< 0.1%
Missing	20261
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%
Mean	1214.8433

Minimum	100
Maximum	10000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	100
5-th percentile	200
Q1	500
median	900
Q3	1500
95-th percentile	3400
Maximum	10000
Range	9900
Interquartile range (IQR)	1000

Descriptive statistics

Standard deviation	1124.2857
Coefficient of variation (CV)	0.92545733
Kurtosis	9.4502587
Mean	1214.8433
Median Absolute Deviation (MAD)	500
Skewness	2.5606618
Sum	4.6591064 × 10⁸
Variance	1264018.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	30662	7.6%
400	29849	7.4%
500	28043	6.9%
600	27189	6.7%
700	25720	6.4%
800	22728	5.6%
900	20655	5.1%
1000	19026	4.7%
200	17370	4.3%
1100	17009	4.2%
Other values (122)	145264	36.0%
(Missing)	20261	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100	5091	1.3%
150	1	< 0.1%
200	17370	4.3%
300	30662	7.6%
350	1	< 0.1%
400	29849	7.4%
500	28043	6.9%
600	27189	6.7%
700	25720	6.4%
800	22728	5.6%

Value	Count	Frequency (%)
10000	51	< 0.1%
9900	25	< 0.1%
9800	24	< 0.1%
9700	23	< 0.1%
9600	23	< 0.1%
9500	22	< 0.1%
9400	25	< 0.1%
9300	31	< 0.1%
9200	31	< 0.1%
9100	31	< 0.1%

O3
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1597
Distinct (%)	0.4%
Missing	13007
Missing (%)	3.2%
Infinite	0
Infinite (%)	0.0%
Mean	58.119327

Minimum	0.2142
Maximum	1071
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0.2142
5-th percentile	2
Q1	11
median	45
Q3	83
95-th percentile	180
Maximum	1071
Range	1070.7858
Interquartile range (IQR)	72

Descriptive statistics

Standard deviation	57.375966
Coefficient of variation (CV)	0.98720975
Kurtosis	6.0740696
Mean	58.119327
Median Absolute Deviation (MAD)	36
Skewness	1.6351637
Sum	22711231
Variance	3292.0015
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	40544	10.0%
3	8245	2.0%
4	7636	1.9%
1	6878	1.7%
5	6129	1.5%
6	5641	1.4%
8	4796	1.2%
7	4642	1.1%
10	3940	1.0%
9	3936	1.0%
Other values (1587)	298382	73.9%
(Missing)	13007	3.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2142	134	< 0.1%
0.4284	119	< 0.1%
0.6426	118	< 0.1%
0.8568	120	< 0.1%
1	6878	1.7%
1.071	138	< 0.1%
1.2852	147	< 0.1%
1.4994	166	< 0.1%
1.7136	125	< 0.1%
1.9278	147	< 0.1%

Value	Count	Frequency (%)
1071	14	< 0.1%
1050	1	< 0.1%
1026	1	< 0.1%
674	1	< 0.1%
673	1	< 0.1%
500	5	< 0.1%
450	1	< 0.1%
444	1	< 0.1%
432	1	< 0.1%
429	1	< 0.1%

TEMP
Real number (ℝ)

HIGH CORRELATION

Distinct	1187
Distinct (%)	0.3%
Missing	264
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	14.088899

Minimum	-19.9
Maximum	41.6
Zeros	2642
Zeros (%)	0.7%
Negative	55474
Negative (%)	13.7%
Memory size	3.1 MiB

Quantile statistics

Minimum	-19.9
5-th percentile	-4
Q1	4
median	15.4
Q3	23.5
95-th percentile	30.7
Maximum	41.6
Range	61.5
Interquartile range (IQR)	19.5

Descriptive statistics

Standard deviation	11.303534
Coefficient of variation (CV)	0.80230067
Kurtosis	-1.0874202
Mean	14.088899
Median Absolute Deviation (MAD)	9.4
Skewness	-0.16869784
Sum	5685040
Variance	127.76987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	3342	0.8%
1	2796	0.7%
0	2642	0.7%
2	2556	0.6%
-1	2436	0.6%
-2	2293	0.6%
-4	1844	0.5%
4	1772	0.4%
5	1680	0.4%
-5	1633	0.4%
Other values (1177)	380518	94.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-19.9	1	< 0.1%
-19.7	1	< 0.1%
-19.5	1	< 0.1%
-18.9	1	< 0.1%
-18.7	1	< 0.1%
-18.5	1	< 0.1%
-18.1	1	< 0.1%
-17.9	1	< 0.1%
-17.4	1	< 0.1%
-17.3	1	< 0.1%

Value	Count	Frequency (%)
41.6	1	< 0.1%
41.4	2	< 0.1%
41.1	3	< 0.1%
41	2	< 0.1%
40.9	1	< 0.1%
40.6	2	< 0.1%
40.5	8	< 0.1%
40.4	3	< 0.1%
40.3	4	< 0.1%
40.2	2	< 0.1%

PRES
Real number (ℝ)

HIGH CORRELATION

Distinct	676
Distinct (%)	0.2%
Missing	265
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1010.2825

Minimum	982.4
Maximum	1042.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	982.4
5-th percentile	994.6
Q1	1002
median	1009.8
Q3	1018.3
95-th percentile	1027.4
Maximum	1042.8
Range	60.4
Interquartile range (IQR)	16.3

Descriptive statistics

Standard deviation	10.356778
Coefficient of variation (CV)	0.010251368
Kurtosis	-0.78291954
Mean	1010.2825
Median Absolute Deviation (MAD)	8.2
Skewness	0.15194784
Sum	4.0766012 × 10⁸
Variance	107.26285
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1019	2712	0.7%
1018	2695	0.7%
1021	2691	0.7%
1015	2602	0.6%
1023	2596	0.6%
1020	2570	0.6%
1017	2554	0.6%
1016	2528	0.6%
1022	2474	0.6%
1024	2455	0.6%
Other values (666)	377634	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
982.4	2	< 0.1%
982.7	2	< 0.1%
982.8	3	< 0.1%
982.9	2	< 0.1%
983	4	< 0.1%
983.2	4	< 0.1%
983.3	3	< 0.1%
983.4	2	< 0.1%
983.5	6	< 0.1%
983.6	4	< 0.1%

Value	Count	Frequency (%)
1042.8	2	< 0.1%
1042.4	1	< 0.1%
1042.3	2	< 0.1%
1042.2	1	< 0.1%
1042	11	< 0.1%
1041.8	8	< 0.1%
1041.7	1	< 0.1%
1041.6	7	< 0.1%
1041.5	2	< 0.1%
1041.4	8	< 0.1%

DEWP
Real number (ℝ)

HIGH CORRELATION

Distinct	645
Distinct (%)	0.2%
Missing	269
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.1572914

Minimum	-43.4
Maximum	29.1
Zeros	828
Zeros (%)	0.2%
Negative	168595
Negative (%)	41.8%
Memory size	3.1 MiB

Quantile statistics

Minimum	-43.4
5-th percentile	-19.4
Q1	-8
median	4.2
Q3	15.5
95-th percentile	22.2
Maximum	29.1
Range	72.5
Interquartile range (IQR)	23.5

Descriptive statistics

Standard deviation	13.617273
Coefficient of variation (CV)	4.3129603
Kurtosis	-1.0781895
Mean	3.1572914
Median Absolute Deviation (MAD)	11.6
Skewness	-0.25002226
Sum	1273989.2
Variance	185.43012
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.6	1559	0.4%
17	1519	0.4%
17.2	1490	0.4%
16.8	1483	0.4%
17.3	1455	0.4%
17.1	1445	0.4%
17.8	1440	0.4%
16.2	1429	0.4%
18.2	1426	0.4%
17.5	1409	0.3%
Other values (635)	388852	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-43.4	1	< 0.1%
-36	1	< 0.1%
-35.7	1	< 0.1%
-35.5	1	< 0.1%
-35.3	7	< 0.1%
-35.1	9	< 0.1%
-35	6	< 0.1%
-34.9	2	< 0.1%
-34.8	7	< 0.1%
-34.6	2	< 0.1%

Value	Count	Frequency (%)
29.1	2	< 0.1%
29	1	< 0.1%
28.8	10	< 0.1%
28.7	12	< 0.1%
28.6	2	< 0.1%
28.5	12	< 0.1%
28.4	14	< 0.1%
28.3	14	< 0.1%
28.2	9	< 0.1%
28.1	9	< 0.1%

RAIN
Real number (ℝ)

SKEWED ZEROS

Distinct	253
Distinct (%)	0.1%
Missing	261
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.067051782

Minimum	0
Maximum	72.5
Zeros	387119
Zeros (%)	95.9%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	72.5
Range	72.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.83784487
Coefficient of variation (CV)	12.49549
Kurtosis	1291.9083
Mean	0.067051782
Median Absolute Deviation (MAD)	0
Skewness	29.440245
Sum	27056.4
Variance	0.70198402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	387119	95.9%
0.1	3689	0.9%
0.2	1823	0.5%
0.3	1374	0.3%
0.4	885	0.2%
0.5	847	0.2%
0.6	698	0.2%
0.7	585	0.1%
0.9	502	0.1%
0.8	482	0.1%
Other values (243)	5511	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	387119	95.9%
0.1	3689	0.9%
0.2	1823	0.5%
0.3	1374	0.3%
0.4	885	0.2%
0.5	847	0.2%
0.6	698	0.2%
0.7	585	0.1%
0.8	482	0.1%
0.9	502	0.1%

Value	Count	Frequency (%)
72.5	3	< 0.1%
52.1	2	< 0.1%
47.7	1	< 0.1%
46.4	6	< 0.1%
45.9	2	< 0.1%
41.9	1	< 0.1%
40.7	3	< 0.1%
39	1	< 0.1%
38.9	1	< 0.1%
37.4	2	< 0.1%

wd
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	1389
Missing (%)	0.3%
Memory size	3.1 MiB

NE	40049
ENE	33262
N	29973
NW	29587
E	29168
Other values (11)	240348

Length

Max length	3
Median length	2
Mean length	2.2381762
Min length	1

Characters and Unicode

Total characters	900613
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NNW
2nd row	N
3rd row	NNW
4th row	NW
5th row	N

Common Values

Value	Count	Frequency (%)
NE	40049	9.9%
ENE	33262	8.2%
N	29973	7.4%
NW	29587	7.3%
E	29168	7.2%
NNE	27247	6.7%
SW	27083	6.7%
NNW	24167	6.0%
WNW	23815	5.9%
ESE	23691	5.9%
Other values (6)	114345	28.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ne	40049	10.0%
ene	33262	8.3%
n	29973	7.4%
nw	29587	7.4%
e	29168	7.2%
nne	27247	6.8%
sw	27083	6.7%
nnw	24167	6.0%
wnw	23815	5.9%
ese	23691	5.9%
Other values (6)	114345	28.4%

Most occurring characters

Value	Count	Frequency (%)
N	259514	28.8%
E	246725	27.4%
W	207045	23.0%
S	187329	20.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	900613	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	259514	28.8%
E	246725	27.4%
W	207045	23.0%
S	187329	20.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	900613	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	259514	28.8%
E	246725	27.4%
W	207045	23.0%
S	187329	20.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	900613	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	259514	28.8%
E	246725	27.4%
W	207045	23.0%
S	187329	20.8%

WSPM
Real number (ℝ)

ZEROS

Distinct	115
Distinct (%)	< 0.1%
Missing	238
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.7183797

Minimum	0
Maximum	13.2
Zeros	10891
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.3
Q1	0.9
median	1.4
Q3	2.2
95-th percentile	4.2
Maximum	13.2
Range	13.2
Interquartile range (IQR)	1.3

Descriptive statistics

Standard deviation	1.2379649
Coefficient of variation (CV)	0.7204257
Kurtosis	3.6915467
Mean	1.7183797
Median Absolute Deviation (MAD)	0.6
Skewness	1.62527
Sum	693431.5
Variance	1.532557
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.1	21486	5.3%
1	21370	5.3%
1.2	21228	5.3%
0.9	20237	5.0%
1.3	19640	4.9%
0.8	18585	4.6%
1.4	17776	4.4%
0.7	16969	4.2%
1.5	16273	4.0%
1.6	15098	3.7%
Other values (105)	214876	53.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10891	2.7%
0.1	4175	1.0%
0.2	4378	1.1%
0.3	2673	0.7%
0.4	7154	1.8%
0.5	10842	2.7%
0.6	13881	3.4%
0.7	16969	4.2%
0.8	18585	4.6%
0.9	20237	5.0%

Value	Count	Frequency (%)
13.2	1	< 0.1%
12.9	1	< 0.1%
12.8	1	< 0.1%
11.8	1	< 0.1%
11.7	1	< 0.1%
11.2	3	< 0.1%
11	1	< 0.1%
10.9	3	< 0.1%
10.7	1	< 0.1%
10.5	3	< 0.1%

station
Categorical

UNIFORM

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Aotizhongxin	33648
Changping	33648
Dingling	33648
Dongsi	33648
Guanyuan	33648
Other values (7)	235536

Length

Max length	13
Median length	10.5
Mean length	8.4166667
Min length	6

Characters and Unicode

Total characters	3398448
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Aotizhongxin
2nd row	Aotizhongxin
3rd row	Aotizhongxin
4th row	Aotizhongxin
5th row	Aotizhongxin

Common Values

Value	Count	Frequency (%)
Aotizhongxin	33648	8.3%
Changping	33648	8.3%
Dingling	33648	8.3%
Dongsi	33648	8.3%
Guanyuan	33648	8.3%
Gucheng	33648	8.3%
Huairou	33648	8.3%
Nongzhanguan	33648	8.3%
Shunyi	33648	8.3%
Tiantan	33648	8.3%
Other values (2)	67296	16.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
aotizhongxin	33648	8.3%
changping	33648	8.3%
dingling	33648	8.3%
dongsi	33648	8.3%
guanyuan	33648	8.3%
gucheng	33648	8.3%
huairou	33648	8.3%
nongzhanguan	33648	8.3%
shunyi	33648	8.3%
tiantan	33648	8.3%
Other values (2)	67296	16.7%

Most occurring characters

Value	Count	Frequency (%)
n	639312	18.8%
i	370128	10.9%
g	370128	10.9%
a	336480	9.9%
u	302832	8.9%
o	235536	6.9%
h	201888	5.9%
l	67296	2.0%
D	67296	2.0%
y	67296	2.0%
Other values (16)	740256	21.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2994672	88.1%
Uppercase Letter	403776	11.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	639312	21.3%
i	370128	12.4%
g	370128	12.4%
a	336480	11.2%
u	302832	10.1%
o	235536	7.9%
h	201888	6.7%
l	67296	2.2%
y	67296	2.2%
s	67296	2.2%
Other values (7)	336480	11.2%

Uppercase Letter

Value	Count	Frequency (%)
D	67296	16.7%
G	67296	16.7%
W	67296	16.7%
C	33648	8.3%
H	33648	8.3%
N	33648	8.3%
S	33648	8.3%
T	33648	8.3%
A	33648	8.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3398448	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	639312	18.8%
i	370128	10.9%
g	370128	10.9%
a	336480	9.9%
u	302832	8.9%
o	235536	6.9%
h	201888	5.9%
l	67296	2.0%
D	67296	2.0%
y	67296	2.0%
Other values (16)	740256	21.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3398448	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	639312	18.8%
i	370128	10.9%
g	370128	10.9%
a	336480	9.9%
u	302832	8.9%
o	235536	6.9%
h	201888	5.9%
l	67296	2.0%
D	67296	2.0%
y	67296	2.0%
Other values (16)	740256	21.8%

Auto

Heatmap
Table

	REF_NO	month	day	hour	PM2.5	PM10	SO2	NO2	CO	O3	TEMP	PRES	DEWP	RAIN	WSPM	year	wd	station
REF_NO	1.000	0.165	0.022	0.001	-0.066	-0.078	-0.289	-0.075	-0.048	-0.043	-0.042	0.117	-0.026	0.019	0.061	0.924	0.069	0.000
month	0.165	1.000	0.009	0.000	-0.004	-0.043	-0.188	0.059	0.061	-0.197	0.046	0.078	0.191	0.037	-0.158	0.116	0.070	0.000
day	0.022	0.009	1.000	0.000	0.025	0.039	0.009	0.028	0.011	-0.015	0.015	0.014	0.023	-0.008	-0.009	0.000	0.023	0.000
hour	0.001	0.000	0.000	1.000	0.010	0.063	0.045	-0.025	-0.025	0.280	0.146	-0.037	-0.012	-0.005	0.164	0.000	0.114	0.000
PM2.5	-0.066	-0.004	0.025	0.010	1.000	0.888	0.494	0.647	0.837	-0.238	-0.027	-0.062	0.232	-0.022	-0.317	0.046	0.059	0.022
PM10	-0.078	-0.043	0.039	0.063	0.888	1.000	0.495	0.634	0.729	-0.197	-0.025	-0.066	0.135	-0.084	-0.239	0.063	0.067	0.036
SO2	-0.289	-0.188	0.009	0.045	0.494	0.495	1.000	0.519	0.562	-0.201	-0.359	0.292	-0.351	-0.151	-0.056	0.099	0.031	0.026
NO2	-0.075	0.059	0.028	-0.025	0.647	0.634	0.519	1.000	0.736	-0.609	-0.280	0.195	-0.032	-0.070	-0.436	0.061	0.091	0.109
CO	-0.048	0.061	0.011	-0.025	0.837	0.729	0.562	0.736	1.000	-0.440	-0.229	0.128	0.084	0.010	-0.382	0.062	0.079	0.040
O3	-0.043	-0.197	-0.015	0.280	-0.238	-0.197	-0.201	-0.609	-0.440	1.000	0.598	-0.451	0.262	-0.011	0.425	0.020	0.146	0.017
TEMP	-0.042	0.046	0.015	0.146	-0.027	-0.025	-0.359	-0.280	-0.229	0.598	1.000	-0.813	0.812	0.031	0.114	0.082	0.100	0.023
PRES	0.117	0.078	0.014	-0.037	-0.062	-0.066	0.292	0.195	0.128	-0.451	-0.813	1.000	-0.748	-0.077	0.027	0.100	0.061	0.075
DEWP	-0.026	0.191	0.023	-0.012	0.232	0.135	-0.351	-0.032	0.084	0.262	0.812	-0.748	1.000	0.175	-0.229	0.087	0.098	0.018
RAIN	0.019	0.037	-0.008	-0.005	-0.022	-0.084	-0.151	-0.070	0.010	-0.011	0.031	-0.077	0.175	1.000	-0.022	0.010	0.010	0.000
WSPM	0.061	-0.158	-0.009	0.164	-0.317	-0.239	-0.056	-0.436	-0.382	0.425	0.114	0.027	-0.229	-0.022	1.000	0.049	0.124	0.044
year	0.924	0.116	0.000	0.000	0.046	0.063	0.099	0.061	0.062	0.020	0.082	0.100	0.087	0.010	0.049	1.000	0.060	0.000
wd	0.069	0.070	0.023	0.114	0.059	0.067	0.031	0.091	0.079	0.146	0.100	0.061	0.098	0.010	0.124	0.060	1.000	0.119
station	0.000	0.000	0.000	0.000	0.022	0.036	0.026	0.109	0.040	0.017	0.023	0.075	0.018	0.000	0.044	0.000	0.119	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	REF_NO	year	month	day	hour	PM2.5	PM10	SO2	NO2	CO	O3	TEMP	PRES	DEWP	wd	WSPM	station
0	1	2013	3	1	0	4.0	4.0	4.0	7.0	300.0	77.0	-0.7	1023.0	-18.8	NNW	4.4	Aotizhongxin
1	2	2013	3	1	1	8.0	8.0	4.0	7.0	300.0	77.0	-1.1	1023.2	-18.2	N	4.7	Aotizhongxin
2	3	2013	3	1	2	7.0	7.0	5.0	10.0	300.0	73.0	-1.1	1023.5	-18.2	NNW	5.6	Aotizhongxin
3	4	2013	3	1	3	6.0	6.0	11.0	11.0	300.0	72.0	-1.4	1024.5	-19.4	NW	3.1	Aotizhongxin
4	5	2013	3	1	4	3.0	3.0	12.0	12.0	300.0	72.0	-2.0	1025.2	-19.5	N	2.0	Aotizhongxin
5	6	2013	3	1	5	5.0	5.0	18.0	18.0	400.0	66.0	-2.2	1025.6	-19.6	N	3.7	Aotizhongxin
6	7	2013	3	1	6	3.0	3.0	18.0	32.0	500.0	50.0	-2.6	1026.5	-19.1	NNE	2.5	Aotizhongxin
7	8	2013	3	1	7	3.0	6.0	19.0	41.0	500.0	43.0	-1.6	1027.4	-19.1	NNW	3.8	Aotizhongxin
8	9	2013	3	1	8	3.0	6.0	16.0	43.0	500.0	45.0	0.1	1028.3	-19.2	NNW	4.1	Aotizhongxin
9	10	2013	3	1	9	3.0	8.0	12.0	28.0	400.0	59.0	1.2	1028.5	-19.3	N	2.6	Aotizhongxin

	REF_NO	year	month	day	hour	PM2.5	PM10	SO2	NO2	CO	O3	TEMP	PRES	DEWP	wd	WSPM	station
403766	33639	2016	12	31	14	399.0	412.0	31.0	198.0	4900.0	6.0	3.8	1021.9	-8.9	SSE	1.0	Wanshouxigong
403767	33640	2016	12	31	15	449.0	524.0	30.0	217.0	5600.0	8.0	3.9	1021.5	-6.1	S	1.4	Wanshouxigong
403768	33641	2016	12	31	16	440.0	440.0	26.0	200.0	4700.0	6.0	2.8	1021.5	-6.6	SSE	0.7	Wanshouxigong
403769	33642	2016	12	31	17	378.0	378.0	20.0	171.0	3800.0	4.0	1.2	1021.4	-5.5	SSE	1.1	Wanshouxigong
403770	33643	2016	12	31	18	392.0	458.0	14.0	160.0	3900.0	3.0	-1.3	1021.9	-6.5	S	0.6	Wanshouxigong
403771	33644	2016	12	31	19	449.0	487.0	10.0	153.0	4500.0	4.0	-1.9	1022.0	-6.1	ESE	0.9	Wanshouxigong
403772	33645	2016	12	31	20	460.0	492.0	12.0	146.0	4100.0	4.0	-2.5	1022.4	-5.5	ENE	0.7	Wanshouxigong
403773	33646	2016	12	31	21	463.0	498.0	12.0	141.0	4400.0	5.0	-3.0	1022.1	-5.3	E	0.9	Wanshouxigong
403774	33647	2016	12	31	22	493.0	537.0	12.0	124.0	5000.0	8.0	-3.0	1022.7	-5.0	SW	0.1	Wanshouxigong
403775	33648	2016	12	31	23	464.0	490.0	8.0	111.0	5400.0	7.0	-4.0	1022.6	-5.7	ENE	0.9	Wanshouxigong

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample